package zzzx.purContract.modifyData;

// 请款单 oa_ht_qkd
// 合同主表 oa_ht_main
public class ModifyContractName {
    // 合同编号 YH-20201202-001
    /**
     * 1.用合同编号 在 tb_sys_bill_header，找 bill_id
     * 2.用bill_id 在 tb_con_jzjc_contract_pay ，找到这个单子
     * ①修改支出合同名称
     * 1. 支出合同主表
     * UPDATE tb_con_jzjc_contract_pay SET contract_name = "“十三五”上海市大型居住社区配套设施建设与满意度评估咨询服务委托协议" WHERE bill_id = "1326774176467386368";
     * 2. 抽象单据表
     * UPDATE tb_sys_bill_header SET bill_information = "“十三五”上海市大型居住社区配套设施建设与满意度评估咨询服务委托协议" WHERE bill_id = "1326774176467386368";
     */

    /**
     * solution1:
     * SELECT bill_id FROM TB_SYS_BILL_HEADER WHERE bill_code = '';
     * SELECT * FROM tb_con_jzjc_contract_pay WHERE bill_id ='';
     *
     *
     *
     *
     * SELECT * FROM tb_con_jzjc_contract_pay WHERE bill_id ='';
     *
     */

    // 合同主表
    String tbName = "TB_CON_CONTRACT_BIG_ACCOUNT";
    String fieldName = "contract_name";

    // 抽象单据表 修改
    public void billTb(){
        String tbName = "tb_sys_bill_header";
        String fieldName = "bill_information";
    }


}
